populating database with processed data.
Processing table S0101
Processing table S1201
Processing table S1501
Processing table S1601
Processing table S1903
Processing table S2403
Processing table S2501
Successfully processesed state 12
In generate cluster shapefiles.
Dropped 81 tracts in state 12 due to outlier detection. PCA/Isolation Forest.
Performing cluster analysis.
Successfully processed state 12

Quick Analysis

Below is a table that aggregates our datapoints by their cluster. We selected 6 clusters (rather arbitrarily) for this exercise. If you are unfamiliar with the general demography of Florida here are some broad strokes.

Coastlines will by and large the richest parts of the state and likely very white.

South Florida, mainly below West Palm Beach is much more hispanic than other parts of the state.

Interior rural parts of the state will likely be white and African American and relatively low-income compared to the rest of the state.

The main cities in Florida are Miami, Orlando, Tampa, Jacksonville and Tallahassee (capital). We should expect to see a nice general diversity of populations around each of these, but some obvious demographic clusters emerging as well.

If we look closely to the NW of Orlando and SE of Ocala there is a trapezoidal shape created by a couple tracts. This corresponds to a wealthier, retirement age cluster and is The Villages: one of the largest retirement communities in the world.

I am a Floridian so I chose this state as a sort of sanity check to ensure that the clusters were making sense and fell roughly where they should be.

	total_pop	median_income	age_15_24	age_25_49	age_50+	white	black_aa	asian	pac_islander	multiple_races	hispanic_any_race	no_hs_diploma	highschool_only	hs_some_college	bachelors	graduate_degree	english_only	engl_plus_other	spanish	indo-european	asian_pac_island	manufct_const	sales	util_logist	fin_it_re	sci_tech	wastemgmt_admin	edu_health_social	hospitality	public_admin	owner_occupied	renter_occupied
0	4197073	82419.504	0.085	0.244	0.464	0.898	0.041	0.030	0.001	0.015	0.104	0.042	0.161	0.246	0.291	0.207	0.838	0.159	0.084	0.051	0.017	0.111	0.137	0.040	0.136	0.122	0.044	0.222	0.101	0.040	0.815	0.185
1	3308776	45205.305	0.124	0.355	0.270	0.717	0.162	0.028	0.001	0.025	0.451	0.173	0.293	0.251	0.158	0.081	0.475	0.516	0.415	0.075	0.016	0.163	0.158	0.063	0.081	0.053	0.076	0.183	0.133	0.032	0.583	0.417
2	6155448	44844.990	0.098	0.270	0.413	0.865	0.081	0.016	0.001	0.016	0.104	0.117	0.337	0.298	0.138	0.072	0.875	0.123	0.083	0.026	0.010	0.166	0.165	0.055	0.078	0.054	0.057	0.207	0.111	0.051	0.764	0.236
3	1848659	28600.271	0.143	0.332	0.256	0.274	0.655	0.013	0.000	0.020	0.147	0.210	0.353	0.251	0.096	0.046	0.739	0.257	0.133	0.110	0.007	0.125	0.158	0.069	0.065	0.028	0.087	0.226	0.147	0.043	0.463	0.537
4	1708186	48924.604	0.114	0.357	0.308	0.871	0.050	0.016	0.000	0.015	0.835	0.186	0.258	0.201	0.195	0.107	0.140	0.845	0.804	0.029	0.008	0.141	0.155	0.083	0.097	0.071	0.057	0.194	0.108	0.028	0.531	0.469
5	3346354	45974.700	0.143	0.367	0.269	0.720	0.174	0.041	0.001	0.029	0.170	0.095	0.239	0.295	0.212	0.115	0.773	0.223	0.135	0.052	0.026	0.113	0.152	0.047	0.101	0.073	0.060	0.216	0.142	0.045	0.455	0.545